SongAlbumRecording
Do You Know What It Means to Miss New Orleans? Definitive Collection, The - Louis Armstrong 3625
   "What a Wonderful World 3903
   "20 4246
   "Harry's Choice! 5774
   "Louis Armstrong in the '30s and in the 40s 9739
   "Pete Fountain's New Orleans 9895

SELECT PCS.Name AS "Song", ALB.Name AS "Album", REC.ID AS "Recording" FROM Recordings REC JOIN Pieces PCS ON PCS.ID = REC.Piece_FK JOIN Albums ALB ON ALB.ID = REC.ALBUM_FK WHERE PCS. Name = "Do You Know What It Means to Miss New Orleans?"